CREATE TRIGGER [dbo].[Trigger_USER_update_last_mod_Date]
    ON [dbo].[USER]
    FOR UPDATE
    AS
	UPDATE dbo.USER
    SET LAST_MOD_DATE = GETDATE()
    WHERE USER_ID IN (SELECT DISTINCT USER_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_EVENT_update_last_mod_Date]
    ON [dbo].[EVENT]
    FOR UPDATE
    AS
	UPDATE dbo.EVENT
    SET LAST_MOD_DATE = GETDATE()
    WHERE EVENT_ID IN (SELECT DISTINCT EVENT_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_EVENT_CAT_update_last_mod_Date]
    ON [dbo].[EVENT_CAT]
    FOR UPDATE
    AS
	UPDATE dbo.EVENT_CAT
    SET LAST_MOD_DATE = GETDATE()
    WHERE EVENT_CAT_ID IN (SELECT DISTINCT EVENT_CAT_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_VCL_update_last_mod_Date]
    ON [dbo].[VOLUNTEER_CONTROL_LIST]
    FOR UPDATE
    AS
	UPDATE dbo.VOLUNTEER_CONTROL_LIST
    SET LAST_MOD_DATE = GETDATE()
    WHERE VCL_ID IN (SELECT DISTINCT VCL_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_FAMILY_update_last_mod_Date]
    ON [dbo].[FAMILY]
    FOR UPDATE
    AS
	UPDATE dbo.FAMILY
    SET LAST_MOD_DATE = GETDATE()
    WHERE FAMILY_ID IN (SELECT DISTINCT FAMILY_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_ORGANIZATION_update_last_mod_Date]
    ON [dbo].[ORGANIZATION]
    FOR UPDATE
    AS
	UPDATE dbo.ORGANIZATION
    SET LAST_MOD_DATE = GETDATE()
    WHERE ORG_ID IN (SELECT DISTINCT ORG_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_USER_CONTACT_update_last_mod_Date]
    ON [dbo].[USER_CONTACT]
    FOR UPDATE
    AS
	UPDATE dbo.USER_CONTACT
    SET LAST_MOD_DATE = GETDATE()
    WHERE USER_CONTACT_ID IN (SELECT DISTINCT USER_CONTACT_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_EVENT_SIGNUP_update_last_mod_Date]
    ON [dbo].[EVENT_SIGNUP]
    FOR UPDATE
    AS
	UPDATE dbo.EVENT_SIGNUP
    SET LAST_MOD_DATE = GETDATE()
    WHERE SIGNUP_ID IN (SELECT DISTINCT SIGNUP_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_EXT_USER_INFO_update_last_mod_Date]
    ON [dbo].[EXTENDED_USER_INFO]
    FOR UPDATE
    AS
	UPDATE dbo.EXTENDED_USER_INFO
    SET LAST_MOD_DATE = GETDATE()
    WHERE EXT_USER_INFO_ID IN (SELECT DISTINCT EXT_USER_INFO_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_USER_INFO_DETAILS_update_last_mod_Date]
    ON [dbo].[EXT_USER_INFO_DETAILS]
    FOR UPDATE
    AS
	UPDATE dbo.EXT_USER_INFO_DETAILS
    SET LAST_MOD_DATE = GETDATE()
    WHERE USER_DETAILS_ID IN (SELECT DISTINCT USER_DETAILS_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_USER_EVENT_PREF_update_last_mod_Date]
    ON [dbo].[USER_EVENT_PREF]
    FOR UPDATE
    AS
	UPDATE dbo.USER_EVENT_PREF
    SET LAST_MOD_DATE = GETDATE()
    WHERE PREF_ID IN (SELECT DISTINCT PREF_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_USER_ROLE_update_last_mod_Date]
    ON [dbo].[USER_ROLE]
    FOR UPDATE
    AS
	UPDATE dbo.USER_ROLE
    SET LAST_MOD_DATE = GETDATE()
    WHERE USER_ROLE_ID IN (SELECT DISTINCT USER_ROLE_ID FROM Inserted);
	
CREATE TRIGGER [dbo].[Trigger_VCL_MEMBERS_update_last_mod_Date]
    ON [dbo].[VCL_MEMBERS]
    FOR UPDATE
    AS
	UPDATE dbo.VCL_MEMBERS
    SET LAST_MOD_DATE = GETDATE()
    WHERE VCL_MEMBER_ID IN (SELECT DISTINCT VCL_MEMBER_ID FROM Inserted);